Database Management
Systems M&IS 44043
Syllabus
Fall 2002
General Information
Course Title: Database Management Systems M&IS 44043
Semester: Fall 2002
Meeting Room: BSA 209
Meeting Times: TR
Instructor: Kholekile Gwebu
Office Hours: Fri
Office: BSA A402
Course
Website: www.personal.kent.edu/~kgwebu/44043
Course Prerequisites
·M&IS24060 SYSTEMS ANALYSIS I
·M&IS24070 PRINC OF SYSTEMS DEVELOP
Course Objective
· Learn the role of databases and database applications in contemporary organizations
· Learn and practice data modeling using the entity-relationship
· Learn and practice developing database designs
· Understand the use of SQL and learn SQL syntax
· Understand the special needs of multi-user database processing and learn
techniques for controlling the
consequences of concurrent data access
· Know the features and functions of a commercial-duty DBMS product and
understand how these are implemented in Oracle/SQL Server
· Learn the need for both database administration and data administration
· Learn emerging Internet technology that is relevant to database processing
Textbook
Title: Database Processing, 8th Edition
Author: David M. Kroenke
Publisher: Prentice Hall
Tentative Schedule
|
Class Meeting |
Topic |
Homework and Quizzes |
Assignment |
|
Aug
27 |
Intro
to DB Processing & DB Development |
Homework
1 |
|
|
Aug
29 |
Overview
and History of DB Processing |
|
Chapter
1 |
|
Sept
3 |
Components
of a Database System |
|
Chapter
2 |
|
Sept
5 |
Components
of a Database System |
|
Chapter
2 |
|
Sept
10 |
Entity-relationship
Model I |
Quiz
1 |
Chapter
3 |
|
Sept
12 |
Entity-relationship
Model II |
|
Chapter
3 |
|
Sept
17 |
The
Relational Model and Normalization I |
|
Chapter
5 |
|
Sept
19 |
Normalization
II |
|
Chapter
5 |
|
Sept
24 |
Mid-Term
Exam |
|
|
|
Sept
26 |
Database
Design using E-R Models I |
|
Chapter
6 |
|
Oct
1 |
Database
Design using E-R Models II |
Homework 2 |
Chapter
6 |
|
Oct
3 |
Foundations
of Relational Implementation |
|
Chapter
8 |
|
Oct
8 |
Relational
Implementation and Relational Algebra |
|
Chapter
8 |
|
Oct
10 |
SQL
I |
|
Chapter
9 |
|
Oct
15 |
SQL
II |
Homework 3 |
Chapter
9 |
|
Oct
17 |
SQL
III |
|
Chapter
9 |
|
Oct
22 |
Exam
II |
|
|
|
Oct
24 |
Database
Application Design |
|
Chapter
10 |
|
Oct
29 |
Database
Application Design |
|
Chapter
10 |
|
Oct
31 |
Database
Application Design |
|
Chapter
10 |
|
Nov
5 |
Database
Administration & DBMS Functions |
Quiz
2 |
Chapter
11 |
|
Nov 7 |
Database
Administration & DBMS Functions |
|
Chapter
11 |
|
Nov
12 |
Oracle
|
|
Chapter
12 |
|
Nov
14 |
Oracle
|
|
Chapter
12 |
|
Nov
19 |
Oracle
|
|
Chapter
12 |
|
Nov
21 |
Oracle |
Quiz
3 |
Chapter
12 |
|
Nov
26 |
Database
Processing Using Internet Technology I |
|
Chapter
14 |
|
Nov
28 |
Thanks
Giving |
|
|
|
Dec
3 |
Database
Processing Using Internet Technology I |
|
Chapter
14 |
|
Dec
5 |
Review |
Quiz
4 |
|
|
Dec
9 |
Final
Exam Week |
|
|
This course is designed to help you develop skills
that will serve you in an ever changing professional environment. In
particular, your text and any other supplementary materials you may acquire are
resources to help you master important concepts. You should take the extra time
to familiarize yourself with them.
Class attendance
Class attendance is not required. However, it is expected. And, you are
responsible for all material covered in class in addition to that assigned
outside of class.
A note on class decorum:
I interpret your coming to class as an expression of your interest in learning
as much as you possibly can. Certainly, you should assume that this is your
classmates' intention in being here. In fairness to your classmates (and me), I
expect you to refrain from talking to others, reading newspapers, sleeping,
playing radios or CDs, making telephone calls and other similar, disruptive
activities. Don't be surprised if I ask you or someone else to leave because of
conduct detrimental to the class. If you simply must study for a test later
that day, stay home, go to the Library, find a bench
outdoors. Don't do it in class.
Students with Disabilities
In accordance with University policy, if you have a disability and require
accommodations to obtain equal access in this course, please contact me at the
beginning of the semester or when given an assignment for which an
accommodation is required. Students with disabilities must verify their
eligibility through the Office of Student Disability Services (SDS) in the
Academic Dishonesty
It is expected that all work you submit for a grade
will be your own. If this is not the case, a failing grade will be assigned for
this course and the instructor reserves the right to pursue additional
sanctions as provided by University rules and regulations. If you are not
familiar with these rules and regulations, you can find them in the current
University Phone Directory.
In particular, each of you must submit your own work. Should two or more of you
submit identical or substantially identical assignments/quizzes/exams/projects,
then I can only assume that one (or more) of you copied from the other(s). In
such a circumstance, every student involved will receive a failing grade for
the course. Additional sanctions may be pursued in accord with University rules
and regulations.
Note: The instructor reserves the right to amend the syllabus.